<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1400px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>IBM SVC Capacity and Performance</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="SVC Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="SVC Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used Capacity (TB)"/></dataSource><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Provisioned</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="SVC Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Provisioned (TB)"/></dataSource><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Subscribed %</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="SVC Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Subscription %"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Free Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="SVC Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Free Capacity (TB)"/></dataSource><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid silver"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Avg IOpS - 90 Days</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="SVC Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Sum of Avg IOpS"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid silver"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Avg Latency (ms) - 90 Days</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton7" refQuery="SVC Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Avg Latency (ms)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###.##' ms'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Workload Activity Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Weekly Trends over Last 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart1" refQuery="Workload Activities">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Node Utilization - AVG"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Node Utilization - MAX"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><percentFormat/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:1480px;height:125px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Sum and Peak of Avg IOpS</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(IOpS from Last 14 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart2" refQuery="SVC Perf Trends">
																																<v2_combinationTypeTooltips/>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels>
																																		<v2_labelControl displayFrequency="7"/></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Time"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Time"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_area seriesType="stacked" lineAreaShape="smooth">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor color="#88B2D3" transparency="50"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																			<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Sum of Avg IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat><CSS value="color:#454545"/></style>
																																		</v2_axisLabels>
																																		<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																																	</v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<defaultStyles>
																																		<defaultStyle refStyle="ch"/>
																																	</defaultStyles>
																																	<CSS value="width:400px;height:175px"/></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_legend>
																																	<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition>
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																</v2_legend>
																															</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-right:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Avg and Peak Latency (ms)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Latency from Last 14 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart3" refQuery="SVC Perf Trends">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_labelControl displayFrequency="7"/></v2_ordinalAxis>
		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Time"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Time"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_area seriesType="stacked" lineAreaShape="smooth">
				<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor color="#88B2D3" transparency="50"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg Latency (ms)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak Latency (ms)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange scale="log">
				<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<dataFormat><numberFormat pattern="###.##' ms'"/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:400px;height:175px"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_legend>
		<v2_legendPosition>
			<v2_legendPreset legendPositionPreset="bottom"/>
		</v2_legendPosition>
		<style>
			<defaultStyles>
				<defaultStyle refStyle="lg"/>
			</defaultStyles>
		</style>
	</v2_legend>
</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Avg and Peak MBps (Throughput)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(MBps from Last 14 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart4" refQuery="SVC Perf Trends">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_labelControl displayFrequency="7"/></v2_ordinalAxis>
		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Time"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Time"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_area seriesType="stacked" lineAreaShape="smooth">
				<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor color="#88B2D3" transparency="50"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Sum of Avg MBps"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak MBps"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange>
				<v2_automaticRange/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<dataFormat><numberFormat pattern="###,###' MBps'"/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:400px;height:175px"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_legend>
		<v2_legendPosition>
			<v2_legendPreset legendPositionPreset="bottom"/>
		</v2_legendPosition>
		<style>
			<defaultStyles>
				<defaultStyle refStyle="lg"/>
			</defaultStyles>
		</style>
	</v2_legend>
</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity and Performance Summary by Array</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Performance Data from Last 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="width:5px;background-color:white"/></style></tableCell><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="SVC Detail" rowsPerPage="100">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="SVC Array"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="SVC Array"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Free (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Free (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Provisioned (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Provisioned (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Subscribed %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Subscribed %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Node Utilization - AVG"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Node Utilization - AVG"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Node Utilization - MAX"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Node Utilization - MAX"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Latency (ms)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Latency (ms)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak MBps"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak MBps"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Backend Array"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Backend Array"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Backend Capacity (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Backend Capacity (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Backend Used (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Backend Used (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;padding-bottom:10px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="width:5px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center;padding-top:5px;padding-bottom:5px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;height:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>      Select SVC Array: </staticValue></dataSource><style><CSS value="font-size:12pt;color:gray;font-weight:bold"/></style></textItem></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><selectValue parameter="sArray" refQuery="SVC Prompt" required="false" selectValueUI="radioGroup"><useItem refDataItem="SVC Name"><displayItem refDataItem="SVC Name"/></useItem><style><CSS value="width:200px;height:650px"/></style><headerText><defaultText>Select SVC Array</defaultText></headerText></selectValue></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><promptButton type="next">
			<contents><textItem><dataSource><staticValue>Apply</staticValue></dataSource></textItem></contents>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="bp"/>
				</defaultStyles>
			<CSS value="background-color:silver"/></style>
		</promptButton></contents><style><CSS value="padding-top:5px;padding-left:12px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>2.32 IBM SVC Capacity and Performance</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="SVC Capacity">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	
		
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
		
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) / ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) as 'Subscription %'
	
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND     	dwh_capacity.storage_dimension.family='SVC'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Subscription %"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL1].[Tier Name]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total"><expression>[SQL1].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL1].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL1].[Provisioned (TB)]</expression></dataItem><dataItem name="Subscription %"><expression>[Provisioned (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="Free Capacity (TB)" aggregate="total"><expression>[Capacity (TB)]-[Used Capacity (TB)]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Name]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="SVC Perf">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
dwh_performance.storage_dimension.name as 'Array',
ROUND(AVG(dwh_performance.volume_daily_performance_fact.totaliops),0) as 'Sum of Avg IOpS',
ROUND(MAX(dwh_performance.volume_daily_performance_fact.totaliopsmax),0) as 'Peak IOpS',
ROUND(AVG(dwh_performance.volume_daily_performance_fact.totalresponsetime),2) as 'Avg Latency (ms)',
ROUND(MAX(dwh_performance.volume_daily_performance_fact.totalresponsetimemax),0) as 'Peak Latency (ms)',
ROUND(AVG(dwh_performance.volume_daily_performance_fact.totalthroughput),0) as 'Sum of Avg MBps',
ROUND(MAX(dwh_performance.volume_daily_performance_fact.totalthroughputmax),0) as 'Peak MBps'

FROM dwh_performance.volume_daily_performance_fact
JOIN dwh_performance.storage_dimension
ON   dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storagetk
AND  dwh_performance.storage_dimension.family LIKE CONCAT('%','SVC','%')
JOIN dwh_performance.date_dimension
ON   dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact 
ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY


GROUP BY dwh_performance.storage_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array"/><mdProjectedItem name="Sum of Avg IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Avg Latency (ms)"/><mdProjectedItem name="Peak Latency (ms)"/><mdProjectedItem name="Sum of Avg MBps"/><mdProjectedItem name="Peak MBps"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Array"><expression>[SQL2].[Array]</expression></dataItem><dataItem name="Sum of Avg IOpS" aggregate="total"><expression>[SQL2].[Sum of Avg IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[SQL2].[Peak IOpS]</expression></dataItem><dataItem name="Avg Latency (ms)" aggregate="average"><expression>[SQL2].[Avg Latency (ms)]</expression></dataItem><dataItem name="Peak Latency (ms)"><expression>[SQL2].[Peak Latency (ms)]</expression></dataItem><dataItem name="Sum of Avg MBps"><expression>[SQL2].[Sum of Avg MBps]</expression></dataItem><dataItem name="Peak MBps"><expression>[SQL2].[Peak MBps]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Array]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="Workload Activities">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	
        nodePerf.array as 'SVC Array',
        DATE(nodePerf.fullDate) AS 'Date',
	ROUND(AVG(nodePerf.nodeUsed), 2) AS 'Node Utilization - AVG',
	MAX(nodePerf.nodeUsed) AS 'Node Utilization - MAX'
	FROM 	(
	SELECT 	dwh_performance.date_dimension.tk dateTk,
		dwh_performance.date_dimension.fullDate fullDate,
		dwh_performance.storage_dimension.tk storageTk,
		dwh_performance.storage_dimension.dataCenter dataCenter,
		dwh_performance.storage_dimension.name array,
		ROUND(MAX(dwh_performance.storage_node_daily_performance_fact.utilization)/100,2) nodeUsed
	FROM 	dwh_performance.storage_node_daily_performance_fact
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.storage_node_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND	dwh_performance.storage_dimension.family='SVC'
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.storage_node_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.repday = 1
	AND 	dwh_performance.date_dimension.fullDate &gt;= 	(	SELECT 	MAX(dwh_performance.date_dimension.fullDate)
									FROM 	dwh_performance.date_dimension
									JOIN 	dwh_performance.storage_node_daily_performance_fact
									ON 	dwh_performance.date_dimension.tk = dwh_performance.storage_node_daily_performance_fact.dateTk ) - INTERVAL 90 DAY
	GROUP BY
		dwh_performance.date_dimension.fullDate,
		dwh_performance.storage_dimension.dataCenter,
		dwh_performance.storage_dimension.name
	) nodePerf

GROUP BY
	nodePerf.array,nodePerf.fullDate</sqlText>
		<mdProjectedItems><mdProjectedItem name="SVC Array"/><mdProjectedItem name="Date"/><mdProjectedItem name="Node Utilization - AVG"/><mdProjectedItem name="Node Utilization - MAX"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="SVC Array"><expression>[SQL3].[SVC Array]</expression></dataItem><dataItem name="Date"><expression>[SQL3].[Date]</expression></dataItem><dataItem name="Node Utilization - AVG" aggregate="average"><expression>[SQL3].[Node Utilization - AVG]</expression></dataItem><dataItem name="Node Utilization - MAX" aggregate="maximum"><expression>[SQL3].[Node Utilization - MAX]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[SVC Array]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="SVC Perf Trends"><source><sqlQuery name="SQL4" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
dwh_performance.storage_dimension.name as 'Array',
ROUND(AVG(dwh_performance.volume_hourly_performance_fact.totaliops),0) as 'Sum of Avg IOpS',
ROUND(MAX(dwh_performance.volume_hourly_performance_fact.totaliopsmax),0) as 'Peak IOpS',
ROUND(AVG(dwh_performance.volume_hourly_performance_fact.totalresponsetime),2) as 'Avg Latency (ms)',
ROUND(MAX(dwh_performance.volume_hourly_performance_fact.totalresponsetimemax),0) as 'Peak Latency (ms)',
ROUND(AVG(dwh_performance.volume_hourly_performance_fact.totalthroughput),0) as 'Sum of Avg MBps',
ROUND(MAX(dwh_performance.volume_hourly_performance_fact.totalthroughputmax),0) as 'Peak MBps',
dwh_performance.date_dimension.fulldate as 'Date',
dwh_performance.time_dimension.hourdatetime as 'Time'


FROM dwh_performance.volume_hourly_performance_fact
JOIN dwh_performance.storage_dimension
ON   dwh_performance.storage_dimension.tk=dwh_performance.volume_hourly_performance_fact.storagetk
AND  dwh_performance.storage_dimension.family LIKE CONCAT('%','SVC','%')
JOIN dwh_performance.date_dimension
ON   dwh_performance.date_dimension.tk=dwh_performance.volume_hourly_performance_fact.datetk
JOIN dwh_performance.time_dimension
ON   dwh_performance.time_dimension.tk=dwh_performance.volume_hourly_performance_fact.timetk

GROUP BY dwh_performance.storage_dimension.tk,  dwh_performance.time_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array"/><mdProjectedItem name="Sum of Avg IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Avg Latency (ms)"/><mdProjectedItem name="Peak Latency (ms)"/><mdProjectedItem name="Sum of Avg MBps"/><mdProjectedItem name="Peak MBps"/><mdProjectedItem name="Date"/><mdProjectedItem name="Time"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Array"><expression>[SQL4].[Array]</expression></dataItem><dataItem name="Sum of Avg IOpS" aggregate="total"><expression>[SQL4].[Sum of Avg IOpS]</expression></dataItem><dataItem name="Peak IOpS" aggregate="maximum"><expression>[SQL4].[Peak IOpS]</expression></dataItem><dataItem name="Avg Latency (ms)" aggregate="average"><expression>[SQL4].[Avg Latency (ms)]</expression></dataItem><dataItem name="Peak Latency (ms)" aggregate="maximum"><expression>[SQL4].[Peak Latency (ms)]</expression></dataItem><dataItem name="Sum of Avg MBps" aggregate="total"><expression>[SQL4].[Sum of Avg MBps]</expression></dataItem><dataItem name="Peak MBps" aggregate="maximum"><expression>[SQL4].[Peak MBps]</expression></dataItem><dataItem name="Date"><expression>[SQL4].[Date]</expression></dataItem><dataItem name="Time"><expression>[SQL4].[Time]</expression></dataItem></selection><detailFilters><detailFilter use="optional"><filterExpression>[Array]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="SVC Detail">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
        nodePerf.array as 'SVC Array',
     
    (SELECT ROUND(SUM(dwh_inventory.storage_pool.totalAllocatedCapacityMB)/1024/1024,2) FROM dwh_inventory.storage
     JOIN dwh_inventory.storage_pool ON dwh_inventory.storage_pool.storageid=dwh_inventory.storage.id
     WHERE dwh_inventory.storage.name=nodePerf.array GROUP BY dwh_inventory.storage.name) as 'Capacity (TB)',

     (SELECT ROUND(SUM(dwh_inventory.storage_pool.totalUsedCapacityMB)/1024/1024,2) FROM dwh_inventory.storage
     JOIN dwh_inventory.storage_pool ON dwh_inventory.storage_pool.storageid=dwh_inventory.storage.id
     WHERE dwh_inventory.storage.name=nodePerf.array GROUP BY dwh_inventory.storage.name) as 'Used (TB)',


(SELECT	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024,2)
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension ON dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN 	dwh_capacity.date_dimension ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND     dwh_capacity.date_dimension.latest=1
WHERE   dwh_capacity.storage_dimension.name=nodePerf.array) as 'Provisioned (TB)',
    

	ROUND(AVG(nodePerf.nodeUsed), 2) AS 'Node Utilization - AVG',
	MAX(nodePerf.nodeUsed) AS 'Node Utilization - MAX',
	ROUND(AVG(volPerf.TotalIOpS),0) as 'Avg IOpS',
	ROUND(MAX(volPerf.TotalIOpS),0) as 'Peak IOpS',
	ROUND(AVG(volPerf.Totallatency),2) as 'Avg Latency (ms)',
	ROUND(MAX(volPerf.Totallatency),2) as 'Peak Latency (ms)',
	ROUND(AVG(volPerf.TotalMBps),0) as 'Avg MBps',
	ROUND(MAX(volPerf.TotalMBps),0) as 'Peak MBps',
	
	
(SELECT
dwh_inventory.storage.name FROM dwh_inventory.storage JOIN dwh_inventory.volume ON dwh_inventory.volume.storageid=dwh_inventory.storage.id
JOIN dwh_inventory.virtual_to_backend_volume ON dwh_inventory.virtual_to_backend_volume.backendvolumeid=dwh_inventory.volume.id
WHERE (SELECT dwh_inventory.storage.name FROM dwh_inventory.storage JOIN dwh_inventory.volume
ON dwh_inventory.volume.storageid=dwh_inventory.storage.id WHERE dwh_inventory.storage.family='SVC' and dwh_inventory.volume.id=dwh_inventory.virtual_to_backend_volume.virtualvolumeid ) 
=nodePerf.array GROUP BY dwh_inventory.storage.id ) as 'Backend Array',

(SELECT
ROUND(SUM(dwh_inventory.volume.capacityMB)/1024/1024,2) FROM dwh_inventory.storage JOIN dwh_inventory.volume ON dwh_inventory.volume.storageid=dwh_inventory.storage.id
JOIN dwh_inventory.virtual_to_backend_volume ON dwh_inventory.virtual_to_backend_volume.backendvolumeid=dwh_inventory.volume.id
WHERE (SELECT dwh_inventory.storage.name FROM dwh_inventory.storage JOIN dwh_inventory.volume
ON dwh_inventory.volume.storageid=dwh_inventory.storage.id WHERE dwh_inventory.storage.family='SVC' and dwh_inventory.volume.id=dwh_inventory.virtual_to_backend_volume.virtualvolumeid ) 
=nodePerf.array GROUP BY dwh_inventory.storage.id ) as 'Backend Capacity (TB)',

(SELECT
ROUND(SUM(dwh_inventory.volume.consumedcapacityMB)/1024/1024,2) FROM dwh_inventory.storage JOIN dwh_inventory.volume ON dwh_inventory.volume.storageid=dwh_inventory.storage.id
JOIN dwh_inventory.virtual_to_backend_volume ON dwh_inventory.virtual_to_backend_volume.backendvolumeid=dwh_inventory.volume.id
WHERE (SELECT dwh_inventory.storage.name FROM dwh_inventory.storage JOIN dwh_inventory.volume
ON dwh_inventory.volume.storageid=dwh_inventory.storage.id WHERE dwh_inventory.storage.family='SVC' and dwh_inventory.volume.id=dwh_inventory.virtual_to_backend_volume.virtualvolumeid ) 
=nodePerf.array GROUP BY dwh_inventory.storage.id ) as 'Backend Used (TB)'
	
	
	
	FROM 	(
	SELECT 	dwh_performance.date_dimension.tk dateTk,
		dwh_performance.date_dimension.fullDate fullDate,
		dwh_performance.storage_dimension.tk storageTk,
		dwh_performance.storage_dimension.dataCenter dataCenter,
		dwh_performance.storage_dimension.name array,
		ROUND(MAX(dwh_performance.storage_node_daily_performance_fact.utilization)/100,2) nodeUsed
	FROM 	dwh_performance.storage_node_daily_performance_fact
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.storage_node_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND	dwh_performance.storage_dimension.family='SVC'
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.storage_node_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.repWeek = 1
	AND 	dwh_performance.date_dimension.fullDate &gt;= 	(	SELECT 	MAX(dwh_performance.date_dimension.fullDate)
									FROM 	dwh_performance.date_dimension
									JOIN 	dwh_performance.storage_node_daily_performance_fact
									ON 	dwh_performance.date_dimension.tk = dwh_performance.storage_node_daily_performance_fact.dateTk ) - INTERVAL 90 DAY
	GROUP BY
		dwh_performance.date_dimension.fullDate,
		dwh_performance.storage_dimension.name
	) nodePerf
JOIN
(
SELECT
dwh_performance.storage_dimension.tk as storagetk,
dwh_performance.date_dimension.tk dateTk,
dwh_performance.volume_daily_performance_fact.totaliops as 'TotalIOpS',
dwh_performance.volume_daily_performance_fact.totalresponsetime as 'TotalLatency',
dwh_performance.volume_daily_performance_fact.totalthroughput as 'TotalMBps'


FROM dwh_performance.volume_daily_performance_fact
JOIN dwh_performance.storage_dimension
ON   dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storagetk
AND  dwh_performance.storage_dimension.family LIKE CONCAT('%','SVC','%')
JOIN dwh_performance.date_dimension
ON   dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact 
ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY


GROUP BY dwh_performance.storage_dimension.name, dwh_performance.date_dimension.fulldate
) volPerf ON volPerf.storagetk=nodePerf.storagetk AND volPerf.datetk=nodePerf.datetk


GROUP BY
	nodePerf.array</sqlText>
		<mdProjectedItems><mdProjectedItem name="SVC Array"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Node Utilization - AVG"/><mdProjectedItem name="Node Utilization - MAX"/><mdProjectedItem name="Avg IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Avg Latency (ms)"/><mdProjectedItem name="Peak Latency (ms)"/><mdProjectedItem name="Avg MBps"/><mdProjectedItem name="Peak MBps"/><mdProjectedItem name="Backend Array"/><mdProjectedItem name="Backend Capacity (TB)"/><mdProjectedItem name="Backend Used (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="SVC Array"><expression>[SQL5].[SVC Array]</expression></dataItem><dataItem name="Capacity (TB)"><expression>[SQL5].[Capacity (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL5].[Used (TB)]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL5].[Provisioned (TB)]</expression></dataItem><dataItem name="Node Utilization - AVG" label="Avg Node Util %" aggregate="average"><expression>[SQL5].[Node Utilization - AVG]</expression></dataItem><dataItem name="Node Utilization - MAX" label="Peak Node Util %" aggregate="maximum"><expression>[SQL5].[Node Utilization - MAX]</expression></dataItem><dataItem name="Avg IOpS"><expression>[SQL5].[Avg IOpS]</expression></dataItem><dataItem name="Peak IOpS" aggregate="maximum"><expression>[SQL5].[Peak IOpS]</expression></dataItem><dataItem name="Avg Latency (ms)"><expression>[SQL5].[Avg Latency (ms)]</expression></dataItem><dataItem name="Peak Latency (ms)" aggregate="maximum"><expression>[SQL5].[Peak Latency (ms)]</expression></dataItem><dataItem name="Avg MBps"><expression>[SQL5].[Avg MBps]</expression></dataItem><dataItem name="Peak MBps" aggregate="maximum"><expression>[SQL5].[Peak MBps]</expression></dataItem><dataItem name="Backend Array"><expression>[SQL5].[Backend Array]</expression></dataItem><dataItem name="Backend Capacity (TB)"><expression>[SQL5].[Backend Capacity (TB)]</expression></dataItem><dataItem name="Backend Used (TB)"><expression>[SQL5].[Backend Used (TB)]</expression></dataItem><dataItem name="Subscribed %"><expression>[Provisioned (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="Free (TB)"><expression>[Capacity (TB)]-[Used (TB)]</expression></dataItem><dataItem name="Used %"><expression>[Used (TB)]/[Capacity (TB)]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[SVC Array]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="SVC Prompt">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT DISTINCT 	
	dwh_capacity.storage_dimension.name as 'SVC Name'
			
		
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND     	dwh_capacity.storage_dimension.family='SVC'
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 90 DAY

GROUP BY
	dwh_capacity.storage_dimension.name
ORDER BY dwh_capacity.storage_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="SVC Name"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="SVC Name"><expression>[SQL6].[SVC Name]</expression></dataItem></selection>
		</query></queries></report>